package com.ny.demo523;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Scanner;

public class UserDao {

    public int addUser(String username,String password) throws SQLException,ClassNotFoundException{
        Connection connection = SqlConnection.getCon();
        String sql ="insert into users(username,password) values(?,?)";
        PreparedStatement preparedStatement =connection.prepareStatement(sql);
        preparedStatement.setString(1,username);
        preparedStatement.setString(2,password);
        return preparedStatement.executeUpdate();
    }

    public Users login(String username,String password )throws SQLException,ClassNotFoundException {
    Users users = null;
    Connection connection =SqlConnection.getCon();
    String sql ="select * from users where username =? and password=?";
    PreparedStatement preparedStatement = connection.prepareStatement(sql);
    preparedStatement.setString(1,username);
    preparedStatement.setString(2,password);
    ResultSet resultSet = preparedStatement.executeQuery();
    if(resultSet.next()){
        users = new Users();
        users.setId(resultSet.getInt("id"));
        users.setUsername(resultSet.getString("username"));
        users.setPassword(resultSet.getString("password"));
    }
    return users;
    }
}
